import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
from plotly import __version__
from plotly.offline import download_plotlyjs, init_notebook_mode, plot, iplot
import plotly.plotly as py
import plotly.graph_objs as go
import seaborn as sns
import cufflinks as cf
init_notebook_mode(connected=True)
cf.go_offline()
path_av = './AviationData.xlsx'
path_df = './df.xlsx'
df_av = pd.read_excel(path_av)
df_df = pd.read_excel(path_df)
df_av.info()
<class 'pandas.core.frame.DataFrame'> RangeIndex: 81366 entries, 0 to 81365 Data columns (total 31 columns): Event Id 81366 non-null object Type 81366 non-null object Accident # 81366 non-null object Event Date 81366 non-null object Location 81366 non-null object Country 81366 non-null object Latitude 81366 non-null object Longitude 81366 non-null object Airport Code 81366 non-null object Airport Name 81366 non-null object Injury Severity 81366 non-null object Aircraft Damage 81366 non-null object Aircraft Category 81366 non-null object Registration Number 81366 non-null object Make 81366 non-null object Model 81366 non-null object Amateur Built 81366 non-null object Number of Engines 81366 non-null object Engine Type 81366 non-null object FAR Description 81366 non-null object Schedule 81366 non-null object Purpose of Flight 81366 non-null object Air Carrier 81366 non-null object Total Fatal Injuries 81366 non-null object Total Serious Injuries 81366 non-null object Total Minor Injuries 81366 non-null object Total Uninjured 81366 non-null object Weather Condition 81366 non-null object Broad Phase of Flight 81366 non-null object Report Status 81366 non-null object Publication Date 81366 non-null object dtypes: object(31) memory usage: 9.6+ MB
df_df.info()
<class 'pandas.core.frame.DataFrame'> Int64Index: 81366 entries, 0 to 81365 Data columns (total 47 columns): Country 80859 non-null object Type 81366 non-null int64 Amateur Built 80749 non-null float64 Number of Engines 81366 non-null int64 Injury Severity 81366 non-null int64 Report_Factual 81366 non-null int64 Report_Foreign 81366 non-null int64 Report_Preliminary 81366 non-null int64 Report_Probable Cause 81366 non-null int64 Purpose_Aerial Application 81366 non-null int64 Purpose_Aerial Observation 81366 non-null int64 Purpose_Air Drop 81366 non-null int64 Purpose_Air Race/Show 81366 non-null int64 Purpose_Banner Tow 81366 non-null int64 Purpose_Business 81366 non-null int64 Purpose_Executive/Corporate 81366 non-null int64 Purpose_External Load 81366 non-null int64 Purpose_Ferry 81366 non-null int64 Purpose_Firefighting 81366 non-null int64 Purpose_Flight Test 81366 non-null int64 Purpose_Glider Tow 81366 non-null int64 Purpose_Instructional 81366 non-null int64 Purpose_Other Work Use 81366 non-null int64 Purpose_Personal 81366 non-null int64 Purpose_Positioning 81366 non-null int64 Purpose_Public Aircraft 81366 non-null int64 Purpose_Public Aircraft - Federal 81366 non-null int64 Purpose_Public Aircraft - Local 81366 non-null int64 Purpose_Public Aircraft - State 81366 non-null int64 Purpose_Skydiving 81366 non-null int64 Purpose_Unknown 81366 non-null int64 Damage_Destroyed 81366 non-null int64 Damage_Minor 81366 non-null int64 Damage_Substantial 81366 non-null int64 Aircraft Category_Airplane 81366 non-null int64 Aircraft Category_Balloon 81366 non-null int64 Aircraft Category_Blimp 81366 non-null int64 Aircraft Category_Glider 81366 non-null int64 Aircraft Category_Gyrocraft 81366 non-null int64 Aircraft Category_Gyroplane 81366 non-null int64 Aircraft Category_Helicopter 81366 non-null int64 Aircraft Category_Powered Parachute 81366 non-null int64 Aircraft Category_Powered-Lift 81366 non-null int64 Aircraft Category_Rocket 81366 non-null int64 Aircraft Category_Ultralight 81366 non-null int64 Aircraft Category_Unknown 81366 non-null int64 Aircraft Category_Weight-Shift 81366 non-null int64 dtypes: float64(1), int64(45), object(1) memory usage: 29.5+ MB
corr = df_df.corr()
plt.figure(figsize=(30,20)) #To adjust the size of graph
sns.heatmap(corr, linewidths=2, fmt=".2f", annot=True) #Use to show values in the boxes
<matplotlib.axes._subplots.AxesSubplot at 0x10d49e50>
df_df[['Injury Severity']].iplot(kind="hist", bins=2)
fatal_df = df_av[(df_av['Injury Severity']==' Fatal ')]
fatal_df
| Event Id | Type | Accident # | Event Date | Location | Country | Latitude | Longitude | Airport Code | Airport Name | ... | Purpose of Flight | Air Carrier | Total Fatal Injuries | Total Serious Injuries | Total Minor Injuries | Total Uninjured | Weather Condition | Broad Phase of Flight | Report Status | Publication Date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | 20180331X84022 | Accident | WPR18FA116 | 03/31/2018 | Santa Paula, CA | United States | 34.3453 | -119.047 | SZP | SANTA PAULA | ... | Personal | 2 | VMC | APPROACH | Preliminary | 04/05/2018 | ||||
| 20 | 20180327X91612 | Accident | WPR18LA113 | 03/27/2018 | Stockton, CA | United States | 37.8478 | -121.516 | N/A | ... | Aerial Application | 1 | VMC | MANEUVERING | Preliminary | 04/04/2018 | |||||
| 22 | 20180326X54912 | Accident | WPR18FA112 | 03/26/2018 | Marina, CA | United States | 36.6756 | -121.757 | OAR | Marina Municipal Airport | ... | Personal | 1 | VMC | TAKEOFF | Preliminary | 04/04/2018 | ||||
| 32 | 20180323X80643 | Accident | CEN18FA126 | 03/21/2018 | Pierce, NE | United States | 42.2386 | -97.5972 | Private | ... | Personal | 1 | VMC | APPROACH | Preliminary | 03/29/2018 | |||||
| 55 | 20180312X03110 | Accident | WPR18FA104 | 03/11/2018 | La Center, WA | United States | ... | Personal | 1 | MANEUVERING | Preliminary | 04/05/2018 | |||||||||
| 59 | 20180311X13013 | Accident | ERA18MA099 | 03/11/2018 | New York, NY | United States | 40.7736 | -73.9394 | N/A | ... | Aerial Observation | 5 | 1 | VMC | STANDING | Preliminary | 03/23/2018 | ||||
| 71 | 20180308X30039 | Accident | CEN18FA116 | 03/08/2018 | Laredo, TX | United States | KLRD | ... | Personal | 2 | VMC | LANDING | Preliminary | 03/12/2018 | |||||||
| 80 | 20180305X44855 | Accident | ERA18LA095 | 03/05/2018 | Beaufort, SC | United States | 32.4122 | -80.6344 | ARW | Beaufort County Airport | ... | Personal | 1 | VMC | TAKEOFF | Preliminary | 03/26/2018 | ||||
| 92 | 20180304X41553 | Accident | ERA18LA094 | 02/28/2018 | Ocean City, MD | United States | 38.2881 | -75.0919 | OXB | OCEAN CITY MUNI | ... | Personal | 2 | VMC | DESCENT | Preliminary | 03/15/2018 | ||||
| 94 | 20180227X14047 | Accident | ERA18FA092 | 02/27/2018 | Georgetown, FL | United States | 29.4306 | -81.6764 | 3FL0 | MOUNT ROYAL | ... | Personal | 2 | VMC | APPROACH | Preliminary | 03/05/2018 | ||||
| 96 | 20180226X95618 | Accident | ERA18FA088 | 02/26/2018 | Greenwood, MS | United States | 33.5067 | -90.27 | N/A | ... | Aerial Application | 1 | VMC | MANEUVERING | Preliminary | 03/16/2018 | |||||
| 101 | 20180225X92244 | Accident | ERA18LA089 | 02/25/2018 | Eustis, FL | United States | 28.8433 | -81.63 | X55 | MID FLORIDA AIR SERVICE | ... | Personal | 1 | VMC | APPROACH | Preliminary | 03/14/2018 | ||||
| 107 | 20180223X23016 | Accident | WPR18FA095 | 02/22/2018 | Monticello, UT | United States | 37.7817 | -109.173 | N/A | ... | Personal | 4 | UNKNOWN | Preliminary | 03/08/2018 | ||||||
| 108 | 20180223X04505 | Accident | CEN18FA108 | 02/22/2018 | Ulysses, KS | United States | 37.6528 | -101.371 | ... | Personal | 2 | VMC | CLIMB | Preliminary | 02/28/2018 | ||||||
| 109 | 20180222X31345 | Accident | CEN18FA107 | 02/22/2018 | Rossville, IN | United States | 40.4647 | -86.6128 | N/A | ... | Business | 3 | IMC | CLIMB | Preliminary | 03/05/2018 | |||||
| 111 | 20180221X04610 | Accident | WPR18FA093 | 02/21/2018 | San Diego, CA | United States | 32.8189 | -117.123 | MYF | Montgomery-Gibbs Executive Air | ... | Personal | 1 | VMC | TAKEOFF | Preliminary | 02/26/2018 | ||||
| 114 | 20180221X93251 | Accident | ERA18FA084 | 02/21/2018 | Bonifay, FL | United States | 30 | -85 | 1J0 | TRI-COUNTY | ... | Flight Test | 1 | VMC | APPROACH | Preliminary | 02/27/2018 | ||||
| 117 | 20180220X11813 | Accident | WPR18FA091 | 02/19/2018 | Minden, NV | United States | 39.0497 | -119.794 | ... | Personal | 1 | VMC | DESCENT | Preliminary | 03/06/2018 | ||||||
| 121 | 20180218X81015 | Accident | CEN18FA101 | 02/18/2018 | Evanston, WY | United States | 41.2881 | -110.982 | EVW | EVANSTON-UINTA COUNTY BURNS FI | ... | Personal | 2 | IMC | APPROACH | Preliminary | 02/27/2018 | ||||
| 124 | 20180220X92338 | Accident | CEN18WA103 | 02/17/2018 | Saint Laurent La Roche, France | France | ... | 3 | CRUISE | Foreign | |||||||||||
| 136 | 20180301X24451 | Accident | CEN18WA110 | 02/12/2018 | El Pozo, Mexico | Mexico | 24.9178 | -107.251 | N/A | ... | 2 | UNKNOWN | Foreign | ||||||||
| 137 | 20180213X20952 | Accident | ANC18FA024 | 02/12/2018 | Chuckanut, WA | United States | 48.655 | -122.465 | N/A | ... | Personal | 1 | VMC | Preliminary | 02/26/2018 | ||||||
| 139 | 20180211X53503 | Accident | WPR18FA088 | 02/11/2018 | AGUA DULCE, CA | United States | 34.4547 | -118.301 | N/A | ... | Personal | 4 | VMC | Preliminary | 02/26/2018 | ||||||
| 142 | 20180321X15750 | Accident | DCA18WA107 | 02/11/2018 | Argunovo, Russia | Russia | ... | 71 | TAKEOFF | Foreign | |||||||||||
| 143 | 20180212X10716 | Accident | CEN18WA096 | 02/11/2018 | Helle, Norway | Norway | 68.2433 | 14.6692 | ... | 2 | TAKEOFF | Foreign | |||||||||
| 144 | 20180210X14603 | Accident | WPR18FA087 | 02/10/2018 | Peach Springs, AZ | United States | 35.9672 | -113.769 | N/A | ... | Papillon Airways, Inc. | 3 | 4 | VMC | MANEUVERING | Preliminary | 02/20/2018 | ||||
| 148 | 20180316X41258 | Accident | ERA18WA108 | 02/09/2018 | Ribeirao Cascalheira, Brazil | Brazil | -12.6 | -51.3833 | N/A | ... | Aerial Application | 1 | MANEUVERING | Foreign | |||||||
| 154 | 20180222X30131 | Accident | ERA18WA085 | 02/07/2018 | Itaituba, Brazil | Brazil | -6.82361 | -56.8456 | N/A | ... | 3 | UNKNOWN | Foreign | ||||||||
| 156 | 20180206X32714 | Accident | WPR18FA084 | 02/06/2018 | Santee, CA | United States | 32.8167 | -116.983 | SEE | GILLESPIE FIELD | ... | Personal | 2 | IMC | TAKEOFF | Preliminary | 03/06/2018 | ||||
| 162 | 20180205X40240 | Accident | ERA18LA083 | 02/05/2018 | Carrabelle, FL | United States | 29.8419 | -84.7011 | X13 | CARRABELLE-THOMPSON | ... | Personal | 1 | VMC | TAKEOFF | Preliminary | 02/08/2018 | ||||
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 81261 | 20020917X02142 | Accident | FTW82FRG21 | 01/17/1982 | PORT MANSFIELD, TX | United States | T05 | PORT MANSFIELD | ... | Unknown | 1 | 0 | 0 | 0 | VMC | APPROACH | Probable Cause | 01/17/1983 | |||
| 81264 | 20020917X01721 | Accident | ATL82FA035 | 01/17/1982 | PICAYUNE, MS | United States | PCU | PICAYUNE-PEARL RIVER CNTY | ... | Unknown | 2 | 0 | 0 | 0 | VMC | TAKEOFF | Probable Cause | 01/17/1983 | |||
| 81269 | 20020917X02096 | Accident | FTW82FA041 | 01/16/1982 | HOUMA, LA | United States | ... | Unknown | OFFSHORE LOGISTICS | 1 | 2 | 0 | 0 | IMC | CRUISE | Probable Cause | 01/16/1983 | ||||
| 81275 | 20020917X01966 | Accident | DEN82FA018 | 01/15/1982 | 28 MI ENE OGDEN, UT | United States | ... | Personal | 3 | 0 | 0 | 0 | VMC | CLIMB | Probable Cause | 01/15/1983 | |||||
| 81282 | 20020917X01907 | Accident | DCA82AA011 | 01/13/1982 | WASHINGTON, DC | United States | WASHINGTON NATIONAL | ... | Unknown | AIR FLORIDA, INC | 78 | 6 | 3 | 0 | IMC | TAKEOFF | Probable Cause | 01/13/1983 | |||
| 81289 | 20020917X01965 | Accident | DEN82FA017 | 01/11/1982 | RIVERTON, WY | United States | RIVERTON REGIONAL | ... | Personal | 4 | 1 | 1 | 0 | IMC | TAKEOFF | Probable Cause | 01/11/1983 | ||||
| 81296 | 20020917X01719 | Accident | ATL82FA032 | 01/10/1982 | HENDERSON, NC | United States | ... | Personal | 1 | 1 | 0 | 0 | VMC | CRUISE | Probable Cause | 01/10/1983 | |||||
| 81307 | 20020917X02414 | Accident | MIA82FLD14 | 01/08/1982 | ODESSA, FL | United States | X41 | W. PASCO | ... | Personal | 1 | 0 | 0 | 0 | IMC | APPROACH | Probable Cause | 01/08/1983 | |||
| 81308 | 20020917X01881 | Accident | CHI82FA024 | 01/08/1982 | NEW PHILADELPHI, OH | United States | PHO | HARRY CLEVER FIELD | ... | Personal | 1 | 1 | 0 | 0 | VMC | APPROACH | Probable Cause | 01/08/1983 | |||
| 81313 | 20020917X01964 | Accident | DEN82FA016 | 01/07/1982 | HELENA, MT | United States | ... | Unknown | ROBERT R. HYLTON | 2 | 0 | 0 | 0 | VMC | CRUISE | Probable Cause | 01/07/1983 | ||||
| 81321 | 20020917X02304 | Accident | LAX82FUM06 | 01/05/1982 | RAMONA, CA | United States | L39 | RAMONA | ... | Business | 3 | 0 | 0 | 0 | IMC | CRUISE | Probable Cause | 01/05/1983 | |||
| 81322 | 20020917X02253 | Accident | LAX82FA036 | 01/05/1982 | BLACK CANYON CI, AZ | United States | ... | Personal | 1 | 0 | 0 | 0 | IMC | CRUISE | Probable Cause | 01/05/1983 | |||||
| 81325 | 20020917X01906 | Accident | DCA82AA009 | 01/05/1982 | ITHACA, NY | United States | TOMPKINS COUNTY | ... | Unknown | EMPIRE AIRLINES | 2 | 0 | 0 | 0 | VMC | APPROACH | Probable Cause | 01/05/1983 | |||
| 81329 | 20020917X02618 | Accident | SEA82FA015 | 01/04/1982 | PLEASANT HILL, OR | United States | ... | Personal | 4 | 0 | 0 | 0 | VMC | CRUISE | Probable Cause | 01/04/1983 | |||||
| 81330 | 20020917X02410 | Accident | MIA82FKA05 | 01/04/1982 | SAINT CROIX | STX | ALEXANDER HAMILTON | ... | Business | 1 | 0 | 1 | 0 | VMC | TAXI | Probable Cause | 01/04/1983 | ||||
| 81331 | 20020917X02254 | Accident | LAX82FA038 | 01/04/1982 | NEAR LAS VEGAS, NV | United States | ... | Unknown | LANG AIR SERVICE | 2 | 0 | 0 | 0 | VMC | CRUISE | Probable Cause | 01/04/1983 | ||||
| 81333 | 20020917X01880 | Accident | CHI82FA019 | 01/04/1982 | FORT WAYNE, IN | United States | ... | Personal | 2 | 2 | 0 | 0 | IMC | CRUISE | Probable Cause | 01/04/1983 | |||||
| 81337 | 20020917X02255 | Accident | LAX82FA040 | 01/03/1982 | 10 NM W LEE VIN, CA | United States | ... | Personal | 2 | 1 | 0 | 0 | IMC | DESCENT | Probable Cause | 01/03/1983 | |||||
| 81341 | 20020917X01905 | Accident | DCA82AA008 | 01/03/1982 | ASHLAND, VA | United States | HANOVER COUNTY | ... | Business | 8 | 0 | 0 | 0 | IMC | APPROACH | Probable Cause | 01/03/1983 | ||||
| 81342 | 20020917X01720 | Accident | ATL82FA033 | 01/03/1982 | PINEHURST, NC | United States | SOP | MOORE COUNTY | ... | Personal | 1 | 0 | 0 | 0 | IMC | APPROACH | Probable Cause | 01/03/1983 | |||
| 81346 | 20020917X02134 | Accident | FTW82FRA14 | 01/02/1982 | HEARNE, TX | United States | T72 | HEARNE MUNICIPAL | ... | Personal | 1 | 0 | 0 | 0 | IMC | TAKEOFF | Probable Cause | 01/02/1983 | |||
| 81347 | 20020917X02119 | Accident | FTW82FPJ10 | 01/02/1982 | CHICKASHA, OK | United States | ... | Personal | 1 | 0 | 0 | 0 | IMC | CRUISE | Probable Cause | 01/02/1983 | |||||
| 81348 | 20020917X02117 | Accident | FTW82FPG08 | 01/02/1982 | LITTLE ROCK, AR | United States | ... | Personal | 2 | 0 | 0 | 0 | IMC | CRUISE | Probable Cause | 01/02/1983 | |||||
| 81353 | 20020917X01656 | Accident | ANC82FAG14 | 01/02/1982 | SKWENTA, AK | United States | ... | Personal | 3 | 0 | 0 | 0 | VMC | UNKNOWN | Probable Cause | 01/02/1983 | |||||
| 81359 | 20001218X45446 | Accident | CHI81LA106 | 08/01/1981 | COTTON, MN | United States | ... | Personal | 4 | 0 | 0 | 0 | IMC | UNKNOWN | Probable Cause | 11/06/2001 | |||||
| 81361 | 20041105X01764 | Accident | CHI79FA064 | 08/02/1979 | Canton, OH | United States | ... | Personal | 1 | 2 | VMC | APPROACH | Probable Cause | 04/16/1980 | |||||||
| 81362 | 20001218X45448 | Accident | LAX96LA321 | 06/19/1977 | EUREKA, CA | United States | ... | Personal | 2 | 0 | 0 | 0 | IMC | CRUISE | Probable Cause | 09/12/2000 | |||||
| 81363 | 20061025X01555 | Accident | NYC07LA005 | 08/30/1974 | Saltville, VA | United States | 36.9222 | -81.8781 | ... | Personal | 3 | IMC | CRUISE | Probable Cause | 02/26/2007 | ||||||
| 81364 | 20001218X45447 | Accident | LAX94LA336 | 07/19/1962 | BRIDGEPORT, CA | United States | ... | Personal | 4 | 0 | 0 | 0 | UNK | UNKNOWN | Probable Cause | 09/19/1996 | |||||
| 81365 | 20001218X45444 | Accident | SEA87LA080 | 10/24/1948 | MOOSE CREEK, ID | United States | ... | Personal | 2 | 0 | 0 | 0 | UNK | CRUISE | Probable Cause |
16291 rows × 31 columns
fatal_df[['Aircraft Category']].iplot(kind='hist')
fatal_df[['Purpose of Flight']].iplot(kind='hist')
fatal_df[['Country']].iplot(kind='hist')
def fatalAutoGraphs(name):
fatal = df_av[(df_av['Injury Severity']==' Fatal ')]
return fatal[[name]].iplot(kind='hist')
fatalAutoGraphs('Aircraft Damage')
def nonFatalAutoGraphs(name):
non_fatal = df_av[(df_av['Injury Severity']==' Non-Fatal ')]
return non_fatal[[name]].iplot(kind='hist')
nonFatalAutoGraphs('Aircraft Damage')
Non fatal injuries are highest when aircraft damage is substantial
df_av
| Event Id | Type | Accident # | Event Date | Location | Country | Latitude | Longitude | Airport Code | Airport Name | ... | Purpose of Flight | Air Carrier | Total Fatal Injuries | Total Serious Injuries | Total Minor Injuries | Total Uninjured | Weather Condition | Broad Phase of Flight | Report Status | Publication Date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20180410X65647 | Accident | GAA18CA206 | 04/10/2018 | Edgewood, NM | United States | 35.0947 | -106.164 | 1N1 | SANDIA AIRPARK ESTATES EAST | ... | Personal | 1 | VMC | Preliminary | 04/10/2018 | |||||
| 1 | 20180410X72014 | Accident | GAA18CA209 | 04/09/2018 | Lake Tahoe, CA | United States | 38.8939 | -119.995 | TVL | LAKE TAHOE | ... | Instructional | 1 | VMC | Preliminary | 04/10/2018 | |||||
| 2 | 20180406X70836 | Accident | GAA18CA203 | 04/06/2018 | Caldwell, ID | United States | 43.6419 | -116.636 | EUL | CALDWELL INDUSTRIAL | ... | Personal | 2 | VMC | Preliminary | 04/10/2018 | |||||
| 3 | 20180409X53403 | Accident | GAA18CA205 | 04/05/2018 | Vernon, TX | United States | 34.2253 | -99.2831 | F05 | WILBARGER COUNTY | ... | Personal | 1 | Preliminary | 04/10/2018 | ||||||
| 4 | 20180402X73754 | Accident | GAA18CA196 | 04/01/2018 | Seldovia, AK | United States | 59.4422 | -151.704 | SOV | SELDOVIA | ... | Instructional | 2 | Preliminary | 04/03/2018 | ||||||
| 5 | 20180401X75919 | Accident | GAA18CA193 | 04/01/2018 | Phoenix, AZ | United States | 33.6889 | -112.082 | DVT | PHOENIX DEER VALLEY | ... | Instructional | 2 | VMC | Preliminary | 04/03/2018 | |||||
| 6 | 20180331X84022 | Accident | WPR18FA116 | 03/31/2018 | Santa Paula, CA | United States | 34.3453 | -119.047 | SZP | SANTA PAULA | ... | Personal | 2 | VMC | APPROACH | Preliminary | 04/05/2018 | ||||
| 7 | 20180405X31138 | Accident | GAA18CA202 | 03/31/2018 | Nephi, UT | United States | 39.7353 | -111.87 | U14 | NEPHI MUNI | ... | 1 | Preliminary | 04/06/2018 | |||||||
| 8 | 20180331X52951 | Accident | GAA18CA192 | 03/31/2018 | Prescott, AZ | United States | 34.65 | -112.427 | PRC | ERNEST A LOVE FIELD | ... | Instructional | 2 | Preliminary | 04/02/2018 | ||||||
| 9 | 20180331X05529 | Accident | CEN18LA131 | 03/31/2018 | Grove, OK | United States | N/A | ... | Personal | 1 | 1 | VMC | Preliminary | 04/03/2018 | |||||||
| 10 | 20180330X51628 | Accident | GAA18CA191 | 03/30/2018 | Dorris, CA | United States | 41.8903 | -121.976 | A32 | BUTTE VALLEY | ... | Personal | 1 | VMC | Preliminary | 04/09/2018 | |||||
| 11 | 20180330X95108 | Accident | GAA18CA190 | 03/30/2018 | Salina, CA | United States | 36.6631 | -121.608 | SNS | SALINAS MUNI | ... | 1 | Preliminary | 04/02/2018 | |||||||
| 12 | 20180330X34903 | Accident | GAA18CA189 | 03/30/2018 | Gila Bend, AZ | United States | 32.9589 | -112.679 | E63 | GILA BEND MUNI | ... | Instructional | 1 | VMC | Preliminary | 04/02/2018 | |||||
| 13 | 20180330X63516 | Accident | GAA18CA188 | 03/30/2018 | Nampa, ID | United States | 43.5833 | -116.523 | MAN | NAMPA MUNI | ... | Personal | 1 | Preliminary | 04/02/2018 | ||||||
| 14 | 20180404X35211 | Accident | GAA18CA200 | 03/29/2018 | Lantana, FL | United States | 26.5931 | -80.085 | LNA | PALM BEACH COUNTY PARK | ... | Personal | 1 | VMC | Preliminary | 04/10/2018 | |||||
| 15 | 20180404X24706 | Accident | GAA18CA199 | 03/29/2018 | New Bedford, MA | United States | 41.6769 | -70.9586 | EWB | NEW BEDFORD RGNL | ... | Instructional | 1 | Preliminary | 04/04/2018 | ||||||
| 16 | 20180329X95659 | Accident | GAA18CA187 | 03/29/2018 | King Salmon, AK | United States | 58.6797 | -156.656 | AKN | KING SALMON | ... | LAKE CLARK AIR INC | 8 | IMC | Preliminary | 04/09/2018 | |||||
| 17 | 20180329X20254 | Accident | GAA18CA186 | 03/29/2018 | Silver Bay, MN | United States | 47.2492 | -91.4156 | BFW | SILVER BAY MUNI | ... | Personal | 1 | VMC | Preliminary | 03/29/2018 | |||||
| 18 | 20180328X44355 | Accident | GAA18CA185 | 03/28/2018 | Cave Creek, AZ | United States | ... | 13 | Preliminary | 03/29/2018 | |||||||||||
| 19 | 20180328X04527 | Accident | ERA18LA117 | 03/28/2018 | Sebring, FL | United States | 27.4625 | -81.3447 | SEF | Sebring Regional Airport | ... | Personal | 3 | VMC | TAXI | Preliminary | 04/06/2018 | ||||
| 20 | 20180327X91612 | Accident | WPR18LA113 | 03/27/2018 | Stockton, CA | United States | 37.8478 | -121.516 | N/A | ... | Aerial Application | 1 | VMC | MANEUVERING | Preliminary | 04/04/2018 | |||||
| 21 | 20180327X95733 | Accident | GAA18CA183 | 03/27/2018 | Fullerton, CA | United States | 33.8719 | -117.98 | FUL | FULLERTON MUNI | ... | Personal | 1 | VMC | Preliminary | 03/28/2018 | |||||
| 22 | 20180326X54912 | Accident | WPR18FA112 | 03/26/2018 | Marina, CA | United States | 36.6756 | -121.757 | OAR | Marina Municipal Airport | ... | Personal | 1 | VMC | TAKEOFF | Preliminary | 04/04/2018 | ||||
| 23 | 20180326X21650 | Accident | GAA18CA179 | 03/26/2018 | Haverhill, NH | United States | 5B9 | ... | Personal | 1 | Preliminary | 03/27/2018 | |||||||||
| 24 | 20180326X24908 | Accident | CEN18LA127 | 03/25/2018 | Fulton, TX | United States | 28.1542 | -96.9758 | 9TE5 | Kalt Ranch Airport | ... | Personal | 1 | VMC | Preliminary | 03/29/2018 | |||||
| 25 | 20180323X13524 | Accident | GAA18CA178 | 03/23/2018 | Hartselle, AL | United States | 34.4072 | -86.9331 | 5M0 | HARTSELLE-MORGAN COUNTY REGION | ... | Personal | 1 | VMC | Preliminary | 03/28/2018 | |||||
| 26 | 20180323X23446 | Accident | GAA18CA175 | 03/23/2018 | Beaver Falls, PA | United States | 40.7725 | -80.3869 | BVI | BEAVER COUNTY | ... | Instructional | 1 | VMC | Preliminary | 03/28/2018 | |||||
| 27 | 20180323X42038 | Accident | ERA18LA115 | 03/23/2018 | Canton, MS | United States | 32.6225 | -90.1031 | N/A | ... | Personal | 1 | VMC | LANDING | Preliminary | 04/06/2018 | |||||
| 28 | 20180327X15528 | Accident | CEN18LA128 | 03/22/2018 | Kansas City, MO | United States | 39.1231 | -94.5928 | MKC | Downtown Air | ... | Personal | 2 | VMC | LANDING | Preliminary | 04/02/2018 | ||||
| 29 | 20180319X90457 | Accident | CEN18LA123 | 03/22/2018 | Dewitt, MI | United States | 42.8875 | -84.7169 | ... | Personal | 1 | VMC | APPROACH | Preliminary | 03/26/2018 | ||||||
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 81336 | 20020917X02333 | Incident | LAX82IA034 | 01/03/1982 | VAN NUYS, CA | United States | VNY | VAN NUYS | ... | Personal | 0 | 0 | 0 | 1 | VMC | APPROACH | Probable Cause | 01/03/1983 | |||
| 81337 | 20020917X02255 | Accident | LAX82FA040 | 01/03/1982 | 10 NM W LEE VIN, CA | United States | ... | Personal | 2 | 1 | 0 | 0 | IMC | DESCENT | Probable Cause | 01/03/1983 | |||||
| 81338 | 20020917X02155 | Accident | LAX82DA035 | 01/03/1982 | SAN CLEMENTINE, CA | United States | ... | Personal | 0 | 0 | 2 | 0 | VMC | MANEUVERING | Probable Cause | 01/03/1983 | |||||
| 81339 | 20020917X01992 | Accident | FTW82DA036 | 01/03/1982 | FORT WORTH, TX | United States | OAK GROVE | ... | Personal | 0 | 0 | 2 | 0 | VMC | APPROACH | Probable Cause | 01/03/1983 | ||||
| 81340 | 20020917X01960 | Accident | DEN82DTI09 | 01/03/1982 | GREENOUGH, MT | United States | ... | Ferry | 0 | 0 | 0 | 1 | VMC | TAKEOFF | Probable Cause | 01/03/1983 | |||||
| 81341 | 20020917X01905 | Accident | DCA82AA008 | 01/03/1982 | ASHLAND, VA | United States | HANOVER COUNTY | ... | Business | 8 | 0 | 0 | 0 | IMC | APPROACH | Probable Cause | 01/03/1983 | ||||
| 81342 | 20020917X01720 | Accident | ATL82FA033 | 01/03/1982 | PINEHURST, NC | United States | SOP | MOORE COUNTY | ... | Personal | 1 | 0 | 0 | 0 | IMC | APPROACH | Probable Cause | 01/03/1983 | |||
| 81343 | 20020917X02481 | Accident | NYC82DA016 | 01/02/1982 | GALETON, PA | United States | 5G6 | CHERRY SPRINGS | ... | Personal | 0 | 0 | 0 | 1 | VMC | TAXI | Probable Cause | 01/02/1983 | |||
| 81344 | 20020917X02339 | Accident | MIA82DA028 | 01/02/1982 | MIAMI, FL | United States | ... | Personal | 0 | 0 | 0 | 2 | VMC | CRUISE | Probable Cause | 01/02/1983 | |||||
| 81345 | 20020917X02148 | Accident | FTW82FRJ07 | 01/02/1982 | HOMER, LA | United States | ... | Personal | 0 | 0 | 1 | 0 | IMC | CRUISE | Probable Cause | 01/02/1983 | |||||
| 81346 | 20020917X02134 | Accident | FTW82FRA14 | 01/02/1982 | HEARNE, TX | United States | T72 | HEARNE MUNICIPAL | ... | Personal | 1 | 0 | 0 | 0 | IMC | TAKEOFF | Probable Cause | 01/02/1983 | |||
| 81347 | 20020917X02119 | Accident | FTW82FPJ10 | 01/02/1982 | CHICKASHA, OK | United States | ... | Personal | 1 | 0 | 0 | 0 | IMC | CRUISE | Probable Cause | 01/02/1983 | |||||
| 81348 | 20020917X02117 | Accident | FTW82FPG08 | 01/02/1982 | LITTLE ROCK, AR | United States | ... | Personal | 2 | 0 | 0 | 0 | IMC | CRUISE | Probable Cause | 01/02/1983 | |||||
| 81349 | 20020917X01962 | Accident | DEN82DTM08 | 01/02/1982 | MIDWAY, UT | United States | FIELD RANCH | ... | Personal | 0 | 0 | 0 | 1 | IMC | TAXI | Probable Cause | 01/02/1983 | ||||
| 81350 | 20020917X01894 | Accident | CHI82FEC08 | 01/02/1982 | YPSILANTI, MI | United States | YIP | WILLOW RUN | ... | Instructional | 0 | 0 | 0 | 1 | VMC | TAKEOFF | Probable Cause | 01/02/1983 | |||
| 81351 | 20020917X01776 | Accident | CHI82DA020 | 01/02/1982 | CHARLOTTE, MI | United States | 49G | TINKERBELL | ... | Personal | 0 | 0 | 0 | 2 | VMC | APPROACH | Probable Cause | 01/02/1983 | |||
| 81352 | 20020917X01657 | Accident | ATL82DA027 | 01/02/1982 | CHAMBLEE, GA | United States | PDK | ... | Unknown | ROCKY MOUNTAIN HELICOPTERS, IN | 0 | 0 | 0 | 1 | VMC | APPROACH | Probable Cause | 01/02/1983 | |||
| 81353 | 20020917X01656 | Accident | ANC82FAG14 | 01/02/1982 | SKWENTA, AK | United States | ... | Personal | 3 | 0 | 0 | 0 | VMC | UNKNOWN | Probable Cause | 01/02/1983 | |||||
| 81354 | 20020909X01562 | Accident | SEA82DA022 | 01/01/1982 | PULLMAN, WA | United States | BLACKBURN AG STRIP | ... | Personal | 0 | 0 | 0 | 2 | VMC | TAKEOFF | Probable Cause | 01/01/1982 | ||||
| 81355 | 20020909X01561 | Accident | NYC82DA015 | 01/01/1982 | EAST HANOVER, NJ | United States | N58 | HANOVER | ... | Business | 0 | 0 | 0 | 2 | IMC | LANDING | Probable Cause | 01/01/1982 | |||
| 81356 | 20020909X01560 | Accident | MIA82DA029 | 01/01/1982 | JACKSONVILLE, FL | United States | JAX | JACKSONVILLE INTL | ... | Personal | 0 | 0 | 3 | 0 | IMC | CRUISE | Probable Cause | 01/01/1982 | |||
| 81357 | 20020909X01559 | Accident | FTW82DA034 | 01/01/1982 | HOBBS, NM | United States | ... | Personal | 0 | 0 | 0 | 1 | VMC | APPROACH | Probable Cause | 01/01/1982 | |||||
| 81358 | 20020909X01558 | Accident | ATL82DKJ10 | 01/01/1982 | TUSKEGEE, AL | United States | TUSKEGEE | ... | Personal | 0 | 0 | 0 | 1 | VMC | LANDING | Probable Cause | 01/01/1982 | ||||
| 81359 | 20001218X45446 | Accident | CHI81LA106 | 08/01/1981 | COTTON, MN | United States | ... | Personal | 4 | 0 | 0 | 0 | IMC | UNKNOWN | Probable Cause | 11/06/2001 | |||||
| 81360 | 20170710X52551 | Accident | NYC79AA106 | 09/17/1979 | Boston, MA | United States | 42.4453 | -70.7583 | N/A | ... | Air Canada | 1 | 44 | VMC | CLIMB | Probable Cause | 09/19/2017 | ||||
| 81361 | 20041105X01764 | Accident | CHI79FA064 | 08/02/1979 | Canton, OH | United States | ... | Personal | 1 | 2 | VMC | APPROACH | Probable Cause | 04/16/1980 | |||||||
| 81362 | 20001218X45448 | Accident | LAX96LA321 | 06/19/1977 | EUREKA, CA | United States | ... | Personal | 2 | 0 | 0 | 0 | IMC | CRUISE | Probable Cause | 09/12/2000 | |||||
| 81363 | 20061025X01555 | Accident | NYC07LA005 | 08/30/1974 | Saltville, VA | United States | 36.9222 | -81.8781 | ... | Personal | 3 | IMC | CRUISE | Probable Cause | 02/26/2007 | ||||||
| 81364 | 20001218X45447 | Accident | LAX94LA336 | 07/19/1962 | BRIDGEPORT, CA | United States | ... | Personal | 4 | 0 | 0 | 0 | UNK | UNKNOWN | Probable Cause | 09/19/1996 | |||||
| 81365 | 20001218X45444 | Accident | SEA87LA080 | 10/24/1948 | MOOSE CREEK, ID | United States | ... | Personal | 2 | 0 | 0 | 0 | UNK | CRUISE | Probable Cause |
81366 rows × 31 columns
df_av['Latitude'].replace(' ', np.nan, inplace=True)
df_av['Longitude'].replace(' ', np.nan, inplace=True)
df_av['Airport Name'].replace(' ', np.nan, inplace=True)
df_av.dropna(subset=['Latitude'], inplace=True)
df_av.dropna(subset=['Longitude'], inplace=True)
df_av.dropna(subset=['Airport Name'], inplace=True)
df_av
| Event Id | Type | Accident # | Event Date | Location | Country | Latitude | Longitude | Airport Code | Airport Name | ... | Purpose of Flight | Air Carrier | Total Fatal Injuries | Total Serious Injuries | Total Minor Injuries | Total Uninjured | Weather Condition | Broad Phase of Flight | Report Status | Publication Date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20180410X65647 | Accident | GAA18CA206 | 04/10/2018 | Edgewood, NM | United States | 35.094722 | -106.164444 | 1N1 | SANDIA AIRPARK ESTATES EAST | ... | Personal | 1 | VMC | Preliminary | 04/10/2018 | |||||
| 1 | 20180410X72014 | Accident | GAA18CA209 | 04/09/2018 | Lake Tahoe, CA | United States | 38.893889 | -119.995277 | TVL | LAKE TAHOE | ... | Instructional | 1 | VMC | Preliminary | 04/10/2018 | |||||
| 2 | 20180406X70836 | Accident | GAA18CA203 | 04/06/2018 | Caldwell, ID | United States | 43.641944 | -116.635833 | EUL | CALDWELL INDUSTRIAL | ... | Personal | 2 | VMC | Preliminary | 04/10/2018 | |||||
| 3 | 20180409X53403 | Accident | GAA18CA205 | 04/05/2018 | Vernon, TX | United States | 34.225278 | -99.283056 | F05 | WILBARGER COUNTY | ... | Personal | 1 | Preliminary | 04/10/2018 | ||||||
| 4 | 20180402X73754 | Accident | GAA18CA196 | 04/01/2018 | Seldovia, AK | United States | 59.442222 | -151.703889 | SOV | SELDOVIA | ... | Instructional | 2 | Preliminary | 04/03/2018 | ||||||
| 5 | 20180401X75919 | Accident | GAA18CA193 | 04/01/2018 | Phoenix, AZ | United States | 33.688889 | -112.081945 | DVT | PHOENIX DEER VALLEY | ... | Instructional | 2 | VMC | Preliminary | 04/03/2018 | |||||
| 6 | 20180331X84022 | Accident | WPR18FA116 | 03/31/2018 | Santa Paula, CA | United States | 34.345277 | -119.047500 | SZP | SANTA PAULA | ... | Personal | 2 | VMC | APPROACH | Preliminary | 04/05/2018 | ||||
| 7 | 20180405X31138 | Accident | GAA18CA202 | 03/31/2018 | Nephi, UT | United States | 39.735277 | -111.870000 | U14 | NEPHI MUNI | ... | 1 | Preliminary | 04/06/2018 | |||||||
| 8 | 20180331X52951 | Accident | GAA18CA192 | 03/31/2018 | Prescott, AZ | United States | 34.650000 | -112.427500 | PRC | ERNEST A LOVE FIELD | ... | Instructional | 2 | Preliminary | 04/02/2018 | ||||||
| 10 | 20180330X51628 | Accident | GAA18CA191 | 03/30/2018 | Dorris, CA | United States | 41.890277 | -121.975556 | A32 | BUTTE VALLEY | ... | Personal | 1 | VMC | Preliminary | 04/09/2018 | |||||
| 11 | 20180330X95108 | Accident | GAA18CA190 | 03/30/2018 | Salina, CA | United States | 36.663056 | -121.607778 | SNS | SALINAS MUNI | ... | 1 | Preliminary | 04/02/2018 | |||||||
| 12 | 20180330X34903 | Accident | GAA18CA189 | 03/30/2018 | Gila Bend, AZ | United States | 32.958889 | -112.679445 | E63 | GILA BEND MUNI | ... | Instructional | 1 | VMC | Preliminary | 04/02/2018 | |||||
| 13 | 20180330X63516 | Accident | GAA18CA188 | 03/30/2018 | Nampa, ID | United States | 43.583333 | -116.523334 | MAN | NAMPA MUNI | ... | Personal | 1 | Preliminary | 04/02/2018 | ||||||
| 14 | 20180404X35211 | Accident | GAA18CA200 | 03/29/2018 | Lantana, FL | United States | 26.593055 | -80.085000 | LNA | PALM BEACH COUNTY PARK | ... | Personal | 1 | VMC | Preliminary | 04/10/2018 | |||||
| 15 | 20180404X24706 | Accident | GAA18CA199 | 03/29/2018 | New Bedford, MA | United States | 41.676945 | -70.958611 | EWB | NEW BEDFORD RGNL | ... | Instructional | 1 | Preliminary | 04/04/2018 | ||||||
| 16 | 20180329X95659 | Accident | GAA18CA187 | 03/29/2018 | King Salmon, AK | United States | 58.679723 | -156.656111 | AKN | KING SALMON | ... | LAKE CLARK AIR INC | 8 | IMC | Preliminary | 04/09/2018 | |||||
| 17 | 20180329X20254 | Accident | GAA18CA186 | 03/29/2018 | Silver Bay, MN | United States | 47.249166 | -91.415556 | BFW | SILVER BAY MUNI | ... | Personal | 1 | VMC | Preliminary | 03/29/2018 | |||||
| 19 | 20180328X04527 | Accident | ERA18LA117 | 03/28/2018 | Sebring, FL | United States | 27.462500 | -81.344722 | SEF | Sebring Regional Airport | ... | Personal | 3 | VMC | TAXI | Preliminary | 04/06/2018 | ||||
| 20 | 20180327X91612 | Accident | WPR18LA113 | 03/27/2018 | Stockton, CA | United States | 37.847777 | -121.516111 | N/A | ... | Aerial Application | 1 | VMC | MANEUVERING | Preliminary | 04/04/2018 | |||||
| 21 | 20180327X95733 | Accident | GAA18CA183 | 03/27/2018 | Fullerton, CA | United States | 33.871945 | -117.979723 | FUL | FULLERTON MUNI | ... | Personal | 1 | VMC | Preliminary | 03/28/2018 | |||||
| 22 | 20180326X54912 | Accident | WPR18FA112 | 03/26/2018 | Marina, CA | United States | 36.675556 | -121.756944 | OAR | Marina Municipal Airport | ... | Personal | 1 | VMC | TAKEOFF | Preliminary | 04/04/2018 | ||||
| 24 | 20180326X24908 | Accident | CEN18LA127 | 03/25/2018 | Fulton, TX | United States | 28.154167 | -96.975834 | 9TE5 | Kalt Ranch Airport | ... | Personal | 1 | VMC | Preliminary | 03/29/2018 | |||||
| 25 | 20180323X13524 | Accident | GAA18CA178 | 03/23/2018 | Hartselle, AL | United States | 34.407222 | -86.933056 | 5M0 | HARTSELLE-MORGAN COUNTY REGION | ... | Personal | 1 | VMC | Preliminary | 03/28/2018 | |||||
| 26 | 20180323X23446 | Accident | GAA18CA175 | 03/23/2018 | Beaver Falls, PA | United States | 40.772500 | -80.386944 | BVI | BEAVER COUNTY | ... | Instructional | 1 | VMC | Preliminary | 03/28/2018 | |||||
| 27 | 20180323X42038 | Accident | ERA18LA115 | 03/23/2018 | Canton, MS | United States | 32.622500 | -90.103056 | N/A | ... | Personal | 1 | VMC | LANDING | Preliminary | 04/06/2018 | |||||
| 28 | 20180327X15528 | Accident | CEN18LA128 | 03/22/2018 | Kansas City, MO | United States | 39.123056 | -94.592777 | MKC | Downtown Air | ... | Personal | 2 | VMC | LANDING | Preliminary | 04/02/2018 | ||||
| 30 | 20180402X10600 | Accident | GAA18CA195 | 03/21/2018 | Knox, IN | United States | 41.325556 | -86.662222 | OXI | STARKE COUNTY | ... | Instructional | 2 | VMC | Preliminary | 04/09/2018 | |||||
| 31 | 20180322X14941 | Accident | CEN18LA125 | 03/21/2018 | Beggs, OK | United States | 35.793611 | -96.029723 | 51OK | Eagle Creek | ... | Personal | 1 | 1 | VMC | TAKEOFF | Preliminary | 03/26/2018 | |||
| 32 | 20180323X80643 | Accident | CEN18FA126 | 03/21/2018 | Pierce, NE | United States | 42.238611 | -97.597222 | Private | ... | Personal | 1 | VMC | APPROACH | Preliminary | 03/29/2018 | |||||
| 33 | 20180323X80752 | Accident | WPR18LA111 | 03/20/2018 | Clatskanie, OR | United States | 46.155000 | 123.237500 | N/A | ... | Personal | 1 | VMC | Preliminary | 04/04/2018 | ||||||
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 33210 | 20001212X20849 | Accident | LAX00LA149 | 04/11/2000 | FRESNO, CA | United States | 36.776111 | -119.719167 | FAT | Fresno Airport | ... | Instructional | 0 | 0 | 0 | 1 | VMC | TAKEOFF | Probable Cause | 12/06/2002 | |
| 33211 | 20001212X20834 | Accident | LAX00FA151 | 04/11/2000 | Fullerton, CA | United States | 33.866667 | -117.966667 | FUL | Fullerton Municipal | ... | Personal | 1 | 0 | 0 | 0 | VMC | TAKEOFF | Probable Cause | 04/15/2003 | |
| 33236 | 20001212X20873 | Accident | MIA00FA129 | 04/05/2000 | MARIANNA, FL | United States | 1.483333 | -75.533333 | MAI | MARIANNA MUNI | ... | Instructional | 3 | VMC | APPROACH | Probable Cause | 01/25/2011 | ||||
| 33245 | 20001212X20830 | Accident | IAD00LA031 | 04/03/2000 | SELINSGROVE, PA | United States | 40.820556 | -76.863889 | SEG | Selinsgrove | ... | Personal | 0 | 0 | 0 | 1 | VMC | GO-AROUND | Probable Cause | 09/30/2003 | |
| 33302 | 20001212X20689 | Accident | MIA00FA118 | 03/26/2000 | Panama City, FL | United States | 30.227778 | -85.719723 | KPFN | Panama City-Bay County Int'l | ... | Personal | 1 | 0 | 0 | 0 | IMC | DESCENT | Probable Cause | 04/15/2003 | |
| 33319 | 20001212X20660 | Accident | LAX00FA134 | 03/24/2000 | RIALTO, CA | United States | 34.118056 | -117.383611 | L67 | Rialto Municipal | ... | Instructional | 1 | 0 | 0 | 0 | VMC | APPROACH | Probable Cause | 11/25/2003 | |
| 33338 | 20001212X20624 | Accident | FTW00FA101 | 03/21/2000 | KILLEEN, TX | United States | 31.085833 | -97.686389 | ILE | Killeen Municipal | ... | American Eagle Airlines, Inc. (DBA: American ... | 0 | 0 | 1 | 35 | IMC | LANDING | Probable Cause | 06/03/2002 | |
| 33379 | 20001212X20664 | Incident | LAX00IA127 | 03/13/2000 | SAN FRANCISCO, CA | United States | 37.620278 | -122.380000 | SFO | SAN FRANCISCO INTL | ... | Unknown | DELTA AIRLINES, INC. | 0 | 0 | 0 | 77 | VMC | TAKEOFF | Probable Cause | 10/31/2006 |
| 33391 | 20001212X20658 | Accident | LAX00FA126 | 03/11/2000 | Fallbrook, CA | United States | 33.354167 | -117.250833 | L18 | Fallbrook Community Airpark | ... | Personal | 1 | 1 | 0 | 0 | VMC | TAKEOFF | Probable Cause | 11/25/2003 | |
| 33405 | 20001212X20669 | Accident | LAX00LA118 | 03/08/2000 | CALIPATRIA, CA | United States | 33.130000 | -115.521667 | CLR | Cliff Hatfield Memorial | ... | Aerial Application | 1 | VMC | TAKEOFF | Probable Cause | 12/06/2002 | ||||
| 33417 | 20001212X20573 | Incident | ANC00IA034 | 03/07/2000 | FAIRBANKS, AK | United States | 64.800000 | -147.866111 | FAI | Fairbanks International | ... | ALASKA AIR GROUP (DBA: ALASKA AIRLINES) | 0 | 0 | 0 | 117 | VMC | TAKEOFF | Probable Cause | 07/01/2002 | |
| 33435 | 20030721X01158 | Accident | ATL00LA031 | 03/03/2000 | Manatee, FL | United States | 27.485277 | -82.534166 | Redder Airport | ... | Personal | 1 | VMC | APPROACH | Probable Cause | 09/30/2003 | |||||
| 33475 | 20001212X20507 | Incident | LAX00IA106 | 02/21/2000 | FRESNO, CA | United States | 36.575000 | -119.091666 | KFAT | Fresno-Yosemite International | ... | Unknown | 0 | 0 | 0 | 20 | VMC | CRUISE | Probable Cause | 04/28/2004 | |
| 33490 | 20030819X01362 | Accident | NYC00LA083 | 02/18/2000 | SANDUSKY, OH | United States | 41.433333 | -82.652222 | SKY | GRIFFIN SANDUSKY | ... | Positioning | 1 | VMC | LANDING | Probable Cause | 11/25/2003 | ||||
| 33506 | 20001212X20505 | Accident | LAX00FA101B | 02/15/2000 | Palm Springs, CA | United States | 33.833333 | -116.516667 | PSP | Palm Springs International | ... | Instructional | 3 | 2 | VMC | APPROACH | Probable Cause | 11/25/2003 | |||
| 33507 | 20001212X20505 | Accident | LAX00FA101A | 02/15/2000 | Palm Springs, CA | United States | 33.833333 | -116.516667 | PSP | Palm Springs International | ... | Instructional | 3 | 2 | VMC | APPROACH | Probable Cause | 11/25/2003 | |||
| 33534 | 20001212X20536 | Accident | MIA00LA091 | 02/09/2000 | MONROE, GA | United States | 33.782500 | -83.692777 | D73 | Monroe-Walton County | ... | Business | 0 | 0 | 0 | 1 | VMC | TAXI | Probable Cause | 09/30/2003 | |
| 33617 | 20001212X20356 | Accident | FTW00FA070 | 01/22/2000 | San Antonio, TX | United States | 29.553611 | -98.483056 | SAT | San Antonio International | ... | Personal | 2 | VMC | TAKEOFF | Probable Cause | 06/04/2002 | ||||
| 33633 | 20001212X20391 | Accident | LAX00LA076 | 01/18/2000 | BRAWLEY, CA | United States | 32.000000 | -115.000000 | N/A | ... | Aerial Application | 0 | 0 | 1 | 0 | VMC | MANEUVERING | Probable Cause | 12/06/2002 | ||
| 33678 | 20001212X20387 | Accident | LAX00LA071 | 01/04/2000 | CHANDLER, AZ | United States | 33.266667 | -111.800000 | Memorial | ... | Instructional | 0 | 0 | 0 | 2 | VMC | APPROACH | Probable Cause | 11/25/2003 | ||
| 35075 | 20001212X19017 | Accident | LAX99FA218B | 06/06/1999 | LOS ANGELES, CA | United States | 33.938611 | -118.408889 | LAX | Los Angeles International | ... | Unknown | 699 | VMC | STANDING | Probable Cause | 11/25/2003 | ||||
| 35076 | 20001212X19017 | Accident | LAX99FA218A | 06/06/1999 | LOS ANGELES, CA | United States | 33.938611 | -118.408889 | LAX | Los Angeles International | ... | Unknown | PHILIPPINE AIRLINES, INC. | 699 | VMC | TAXI | Probable Cause | 11/25/2003 | |||
| 35777 | 20001205X00119 | Incident | ANC99IA027 | 02/05/1999 | FAIRBANKS, AK | United States | 64.800000 | -147.866111 | FAI | Fairbanks International | ... | ALASKA AIR GROUP, INC (DBA: ALASKA AIRLINES) | 0 | 0 | 0 | 138 | IMC | TAKEOFF | Probable Cause | 07/01/2002 | |
| 35960 | 20001211X11573 | Accident | LAX99FA051 | 12/17/1998 | Los Angeles, CA | United States | 33.948611 | -118.413611 | LAX | Los Angeles International | ... | Unknown | Clay Lacy (DBA: Clay Lacy Aviation) | 0 | 0 | 0 | 7 | VMC | CRUISE | Probable Cause | 11/25/2003 |
| 36165 | 20041203X01907 | Accident | ATL99FA136 | 11/04/1998 | Robbinsville, NC | United States | 35.389722 | -83.920556 | K6A3 | Andrews-Murphy | ... | Personal | 1 | IMC | CRUISE | Probable Cause | 12/28/2006 | ||||
| 36498 | 20001211X11043 | Accident | FTW98FA380 | 09/11/1998 | Houston, TX | United States | 29.607222 | -95.158611 | EFD | Ellington Field | ... | 0 | 0 | 0 | 2 | IMC | APPROACH | Probable Cause | 02/26/2007 | ||
| 42623 | 20011127X02295 | Accident | NYC96FA192 | 11/28/1995 | Marlinton, WV | United States | 38.335000 | -80.280000 | 48I | Braxton County | ... | Positioning | 1 | IMC | CRUISE | Probable Cause | 01/16/2003 | ||||
| 50002 | 20170710X10920 | Accident | FTW92FA224 | 09/05/1992 | Alpine, TX | United States | 30.383611 | -103.783334 | N/A | ... | Personal | 1 | 1 | VMC | UNKNOWN | Probable Cause | 09/19/2017 | ||||
| 80772 | 20080417X00504 | Accident | MIA08CA076 | 03/16/1982 | Mobile, AL | United States | 30.757778 | -88.355555 | MOB | MOBILE REGIONAL | ... | Unknown | 1 | IMC | LANDING | Probable Cause | 04/30/2008 | ||||
| 81360 | 20170710X52551 | Accident | NYC79AA106 | 09/17/1979 | Boston, MA | United States | 42.445277 | -70.758333 | N/A | ... | Air Canada | 1 | 44 | VMC | CLIMB | Probable Cause | 09/19/2017 |
20663 rows × 31 columns
mapbox_access_token = 'pk.eyJ1IjoibmFuYXdhcmV0IiwiYSI6ImNqZnlkOHpwaTVvcjgzMHBvdW55c2lzcHIifQ.PiO1zMvZi1UHjwXl5FcIbg'
data = Data([
Scattermapbox(
lat=df_av['Latitude'].tolist(),
lon=df_av['Longitude'].tolist(),
mode='markers',
marker=Marker(
size=3
),
text=df_av['Airport Name'].tolist(),
)
])
layout = Layout(
autosize=True,
hovermode='closest',
mapbox=dict(
accesstoken=mapbox_access_token,
bearing=0,
center=dict(
lat=0,
lon=0
),
pitch=0,
zoom=0
),
)
fig = dict(data=data, layout=layout)
py.iplot(fig, filename='Multiple Mapbox')